[dbo].[ServiceStatusRef]

Property	Value
Created	10:31:38 AM Tuesday, March 02, 2010
Last Modified	11:40:08 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	ServiceStatusCode	nvarchar(25)	50
	ServiceStatusDesc	nvarchar(100)	200

	Name	Columns	Unique
	PK_ServiceStatusRef	ServiceStatusCode
	AK_ServiceStatusRef_ServiceStatusDesc	ServiceStatusDesc

SQL Script

CREATE TABLE [dbo].[ServiceStatusRef]
(
[ServiceStatusCode] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ServiceStatusDesc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ServiceStatusRef] ADD CONSTRAINT [PK_ServiceStatusRef] PRIMARY KEY CLUSTERED ([ServiceStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServiceStatusRef] ADD CONSTRAINT [AK_ServiceStatusRef_ServiceStatusDesc] UNIQUE NONCLUSTERED ([ServiceStatusDesc]) ON [PRIMARY]
GO